Paste the last cut or copied data
You can paste previously copied or cut data from the clipboard. If a range of cells, rows or columns was copied or cut, the data will take the same size range when inserted.
|
Inserting data into non-empty cells or ranges deletes the previous data without warning. To retain existing data, use shift cell insertion. Exception: for ranges with filtered cells, shift insertion is not available. |
When pasting into a range containing hidden or filtered cells, only visible cells will be overwritten. You cannot paste into such a range:
–A range with merged cells.
–A range containing an entire pivot table.
–Ranges containing an entire table.
–Array formulas.
Data from the clipboard can be pasted while retaining or discarding the original formatting.
